CREATE TABLE "PROVINCE" 
   (	"ID" NUMBER(10,0), 
	"REGION_ID" VARCHAR2(2 BYTE), 
	"NAME" VARCHAR2(50 BYTE), 
	"LNG" FLOAT(126), 
	"LAT" FLOAT(126), 
	"ENTRY_USER_ID" NUMBER(10,0), 
	"ENTRY_USER_NAME" VARCHAR2(50 BYTE), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMBER(10,0), 
	"UPDATE_USER_NAME" VARCHAR2(50 BYTE), 
	"UPDATE_DATE_TIME" DATE, 
	"SO_TRANSFER_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;

   
  CREATE UNIQUE INDEX "PROVINCE_PK" ON "PROVINCE" ("ID") ;


  ALTER TABLE "PROVINCE" ADD CONSTRAINT "PROVINCE_PK" PRIMARY KEY ("ID", "NAME");
  ALTER TABLE "PROVINCE" MODIFY ("NAME" NOT NULL ENABLE);



  REM INSERTING into PROVINCE
SET DEFINE OFF;
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (108,'03','Hau Giang',null,null,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (107,'01','Dien Bien',103.0201721,21.40576957,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (1,'01','Ha Noi',105.851592,21.029187,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (2,'03','TPHCM',106.698365,10.77187,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (3,'01','Hung Yen',105.9183311,20.90207638,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (4,'02','Da Nang',108.222398,16.071722,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (5,'02','Khanh Hoa',109.1891,12.2472,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (6,'03','Binh Duong',106.6518402,10.97860553,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (7,'01','Bac Ninh',105.9566116,21.114929,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (8,'03','Dong Nai',106.8787766,10.96013098,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (9,'03','An Giang',105.4354477,10.37301106,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (10,'03','Ba Ria VT',107.0871735,10.36456816,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (11,'03','Binh Thuan',108.1013918,10.9317112,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (12,'01','Hai Phong',106.6648865,20.8671529,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (13,'03','Lam Dong',108.445015,11.94562408,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (14,'03','Ninh Thuan',108.9907265,11.56614377,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (15,'02','Quang Ngai',108.8000107,15.12151312,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (16,'02','Binh Dinh',109.2301941,13.7760671,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (17,'03','Soc Trang',105.9748077,9.60413506,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (18,'03','Kien Giang',105.0938416,9.98034714,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (19,'02','Quang Nam',108.3303452,15.8795334,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (20,'01','Quang Ninh',107.0397949,20.96336321,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (21,'02','TT Hue',107.5746918,16.4724687,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (22,'03','Can Tho',105.7808304,10.03528819,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (23,'01','Vinh Phuc',105.610714,21.3125648,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (24,'01','Phu Tho',105.4158783,21.3207206,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (25,'01','Bac Giang',106.1849213,21.2906539,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (26,'01','Ha Nam',105.9119797,20.5418288,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (27,'01','Hai Duong',106.3269711,20.9379537,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (28,'01','Thai Binh',106.3438797,20.4495325,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (29,'01','Thai Nguyen',105.8333588,21.5865736,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (31,'03','Phu Yen',109.3095016,13.0888417,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (32,'03','Tay Ninh',106.0901213,11.3147774,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (33,'03','Long An',106.4134026,10.5370957,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (34,'03','Bac Lieu',105.7228088,9.2905305,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (35,'03','Dak Lak',108.0433273,12.6817077,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (36,'03','Gia Lai',108.0134583,13.9813796,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (37,'01','Thanh Hoa',105.7781696,19.8091847,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (38,'01','Nghe An',105.6872749,18.6737309,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (39,'01','Ha Tinh',105.8992767,18.3435275,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (40,'01','Ninh Binh',105.9742928,20.2506019,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (41,'02','Quang Tri',107.0973015,16.8168655,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (42,'03','Ben Tre',106.3775253,10.2417827,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (43,'03','Ca Mau',105.1484299,9.1753131,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (44,'03','Dong Thap',105.762291,10.2919498,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (45,'03','Tien Giang',106.3624191,10.3571382,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (46,'03','Tra Vinh',106.3402748,9.9299623,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (47,'03','Vinh Long',105.967083,10.2497221,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (48,'03','Kon Tum',107.9968071,14.39087102,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (49,'03','Binh Phuoc',106.9134521,11.55807122,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (50,'02','Quang Binh',106.6012859,17.48568314,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (51,'01','Hoa Binh',105.3345108,20.83426694,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (52,'01','Son La',103.9066315,21.34310671,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (54,'01','Nam Dinh',106.168313,20.42174433,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (100,'01','Lang Son',106.7577778,21.8477778,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (101,'01','Bac Kan',105.828499,22.146061,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (102,'01','Tuyen Quang',105.2166667,21.8166667,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (103,'01','Yen Bai',104.875397,21.70532,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (104,'01','Cao Bang',106.25,22.6730556,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (105,'01','Ha Giang',104.984001,22.833111,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (106,'01','Lao Cai',103.95,22.4833333,null,null,null,null,null,null,'Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into PROVINCE (ID,REGION_ID,NAME,LNG,LAT,ENTRY_USER_ID,ENTRY_USER_NAME,ENTRY_DATE_TIME,UPDATE_USER_ID,UPDATE_USER_NAME,UPDATE_DATE_TIME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values (109,'03','Dak Nong',null,null,null,null,null,null,null,null,'Y',to_date('20-OCT-14','DD-MON-RR'));